Reporte del Analisis

Dataset statistics

Number of variables	41
Number of observations	198900
Missing cells	98472
Missing cells (%)	1.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	313.8 MiB
Average record size in memory	1.6 KiB

Variable types

Text	8
Numeric	15
Categorical	6
DateTime	7
Boolean	5

Alerts

`Estimated Cost` is highly overall correlated with `Revised Cost`	High correlation
`Existing Construction Type` is highly overall correlated with `Existing Construction Type Description` and 2 other fields	High correlation
`Existing Construction Type Description` is highly overall correlated with `Existing Construction Type` and 2 other fields	High correlation
`Existing Units` is highly overall correlated with `Proposed Units`	High correlation
`Neighborhoods - Analysis Boundaries` is highly overall correlated with `Supervisor District` and 1 other fields	High correlation
`Number of Existing Stories` is highly overall correlated with `Number of Proposed Stories`	High correlation
`Number of Proposed Stories` is highly overall correlated with `Number of Existing Stories`	High correlation
`Permit Type` is highly overall correlated with `Permit Type Definition` and 1 other fields	High correlation
`Permit Type Definition` is highly overall correlated with `Permit Type` and 1 other fields	High correlation
`Proposed Construction Type` is highly overall correlated with `Existing Construction Type` and 2 other fields	High correlation
`Proposed Construction Type Description` is highly overall correlated with `Existing Construction Type` and 2 other fields	High correlation
`Proposed Units` is highly overall correlated with `Existing Units`	High correlation
`Revised Cost` is highly overall correlated with `Estimated Cost`	High correlation
`Site Permit` is highly overall correlated with `Permit Type` and 2 other fields	High correlation
`Structural Notification` is highly overall correlated with `Site Permit`	High correlation
`Supervisor District` is highly overall correlated with `Neighborhoods - Analysis Boundaries`	High correlation
`Zipcode` is highly overall correlated with `Neighborhoods - Analysis Boundaries`	High correlation
`Permit Type Definition` is highly imbalanced (79.7%)	Imbalance
`Street Suffix` is highly imbalanced (70.1%)	Imbalance
`Current Status` is highly imbalanced (60.4%)	Imbalance
`Structural Notification` is highly imbalanced (78.2%)	Imbalance
`Voluntary Soft-Story Retrofit` is highly imbalanced (99.8%)	Imbalance
`Fire Only Permit` is highly imbalanced (54.8%)	Imbalance
`TIDF Compliance` is highly imbalanced (> 99.9%)	Imbalance
`Site Permit` is highly imbalanced (82.1%)	Imbalance
`Completed Date` has 59463 (29.9%) missing values	Missing
`Plansets` has 37309 (18.8%) missing values	Missing
`Unit` is highly skewed (γ1 = 21.14443891)	Skewed
`Estimated Cost` is highly skewed (γ1 = 89.27829995)	Skewed
`Revised Cost` is highly skewed (γ1 = 100.9590765)	Skewed
`Plansets` is highly skewed (γ1 = 400.8322084)	Skewed
`Existing Construction Type` is highly skewed (γ1 = 39.8686473)	Skewed
`Record ID` has unique values	Unique
`Unit` has 169421 (85.2%) zeros	Zeros
`Number of Existing Stories` has 42784 (21.5%) zeros	Zeros
`Number of Proposed Stories` has 39374 (19.8%) zeros	Zeros
`Existing Units` has 29134 (14.6%) zeros	Zeros
`Proposed Units` has 28632 (14.4%) zeros	Zeros
`Plansets` has 63244 (31.8%) zeros	Zeros

Reproduction

Analysis started	2024-08-30 23:17:27.217125
Analysis finished	2024-08-30 23:20:12.909591
Duration	2 minutes and 45.69 seconds
Software version	ydata-profiling vv4.9.0
Download configuration	config.json

Permit Number
Text

Distinct	181495
Distinct (%)	91.2%
Missing	0
Missing (%)	0.0%
Memory size	14.4 MiB

Length

Max length	12
Median length	12
Mean length	11.063273
Min length	7

Characters and Unicode

Total characters	2200485
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	167282 ?
Unique (%)	84.1%

Sample

1st row	M788927
2nd row	201305318356
3rd row	201705106205
4th row	201410279983
5th row	201310280388

Value	Count	Frequency (%)
201602179765	101	0.1%
201602179758	66	< 0.1%
201602179775	30	< 0.1%
201702239990	9	< 0.1%
201409166451	9	< 0.1%
201708165004	9	< 0.1%
201702099112	8	< 0.1%
201707061162	8	< 0.1%
201604285989	8	< 0.1%
201604074211	8	< 0.1%
Other values (181485)	198644	99.9%

Most occurring characters

Value	Count	Frequency (%)
0	445620	20.3%
1	376235	17.1%
2	338882	15.4%
7	174079	7.9%
6	150943	6.9%
4	147666	6.7%
3	145527	6.6%
5	144929	6.6%
8	130425	5.9%
9	108916	4.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2200485	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	445620	20.3%
1	376235	17.1%
2	338882	15.4%
7	174079	7.9%
6	150943	6.9%
4	147666	6.7%
3	145527	6.6%
5	144929	6.6%
8	130425	5.9%
9	108916	4.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2200485	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	445620	20.3%
1	376235	17.1%
2	338882	15.4%
7	174079	7.9%
6	150943	6.9%
4	147666	6.7%
3	145527	6.6%
5	144929	6.6%
8	130425	5.9%
9	108916	4.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2200485	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	445620	20.3%
1	376235	17.1%
2	338882	15.4%
7	174079	7.9%
6	150943	6.9%
4	147666	6.7%
3	145527	6.6%
5	144929	6.6%
8	130425	5.9%
9	108916	4.9%

Permit Type
Real number (ℝ)

HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.5223228

Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	8
median	8
Q3	8
95-th percentile	8
Maximum	8
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.4574508
Coefficient of variation (CV)	0.19375011
Kurtosis	6.0363783
Mean	7.5223228
Median Absolute Deviation (MAD)	0
Skewness	-2.7990091
Sum	1496190
Variance	2.124163
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
8	178844	89.9%
3	14663	7.4%
4	2892	1.5%
2	950	0.5%
6	600	0.3%
7	511	0.3%
1	349	0.2%
5	91	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	349	0.2%
2	950	0.5%
3	14663	7.4%
4	2892	1.5%
5	91	< 0.1%
6	600	0.3%
7	511	0.3%
8	178844	89.9%

Value	Count	Frequency (%)
8	178844	89.9%
7	511	0.3%
6	600	0.3%
5	91	< 0.1%
4	2892	1.5%
3	14663	7.4%
2	950	0.5%
1	349	0.2%

Permit Type Definition
Categorical

HIGH CORRELATION IMBALANCE

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.6 MiB

otc alterations permit	178844
additions alterations or repairs	14663
sign - erect	2892
new construction wood frame	950
demolitions	600
Other values (3)	951

Length

Max length	35
Median length	22
Mean length	22.572785
Min length	11

Characters and Unicode

Total characters	4489727
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	otc alterations permit
2nd row	otc alterations permit
3rd row	otc alterations permit
4th row	otc alterations permit
5th row	otc alterations permit

Common Values

Value	Count	Frequency (%)
otc alterations permit	178844	89.9%
additions alterations or repairs	14663	7.4%
sign - erect	2892	1.5%
new construction wood frame	950	0.5%
demolitions	600	0.3%
wall or painted sign	511	0.3%
new construction	349	0.2%
grade or quarry or fill or excavate	91	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
alterations	193507	31.6%
otc	178844	29.2%
permit	178844	29.2%
or	15447	2.5%
additions	14663	2.4%
repairs	14663	2.4%
sign	3403	0.6%
	2892	0.5%
erect	2892	0.5%
construction	1299	0.2%
Other values (10)	5185	0.8%

Most occurring characters

Value	Count	Frequency (%)
t	766057	17.1%
i	422844	9.4%
r	422538	9.4%
a	418676	9.3%
	412739	9.2%
o	408159	9.1%
e	396431	8.8%
s	228135	5.1%
n	216581	4.8%
l	195311	4.4%
Other values (13)	602256	13.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4489727	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	766057	17.1%
i	422844	9.4%
r	422538	9.4%
a	418676	9.3%
	412739	9.2%
o	408159	9.1%
e	396431	8.8%
s	228135	5.1%
n	216581	4.8%
l	195311	4.4%
Other values (13)	602256	13.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4489727	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	766057	17.1%
i	422844	9.4%
r	422538	9.4%
a	418676	9.3%
	412739	9.2%
o	408159	9.1%
e	396431	8.8%
s	228135	5.1%
n	216581	4.8%
l	195311	4.4%
Other values (13)	602256	13.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4489727	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	766057	17.1%
i	422844	9.4%
r	422538	9.4%
a	418676	9.3%
	412739	9.2%
o	408159	9.1%
e	396431	8.8%
s	228135	5.1%
n	216581	4.8%
l	195311	4.4%
Other values (13)	602256	13.4%

Permit Creation Date
Date

Distinct	1292
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

Minimum	2012-03-28 00:00:00
Maximum	2018-12-02 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Block
Text

Distinct	4896
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Memory size	13.1 MiB

Length

Max length	5
Median length	4
Mean length	4.0363901
Min length	3

Characters and Unicode

Total characters	802838
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	124 ?
Unique (%)	0.1%

Sample

1st row	0215
2nd row	1810
3rd row	5700
4th row	0661
5th row	3642

Value	Count	Frequency (%)
3708	1195	0.6%
3735	750	0.4%
7331	680	0.3%
0289	640	0.3%
3709	584	0.3%
3717	578	0.3%
3707	576	0.3%
3721	567	0.3%
3706	561	0.3%
0259	554	0.3%
Other values (4886)	192215	96.6%

Most occurring characters

Value	Count	Frequency (%)
0	124324	15.5%
3	97522	12.1%
1	96591	12.0%
2	85369	10.6%
5	80945	10.1%
6	77731	9.7%
7	73540	9.2%
4	60015	7.5%
8	50674	6.3%
9	48897	6.1%
Other values (9)	7230	0.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	802838	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	124324	15.5%
3	97522	12.1%
1	96591	12.0%
2	85369	10.6%
5	80945	10.1%
6	77731	9.7%
7	73540	9.2%
4	60015	7.5%
8	50674	6.3%
9	48897	6.1%
Other values (9)	7230	0.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	802838	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	124324	15.5%
3	97522	12.1%
1	96591	12.0%
2	85369	10.6%
5	80945	10.1%
6	77731	9.7%
7	73540	9.2%
4	60015	7.5%
8	50674	6.3%
9	48897	6.1%
Other values (9)	7230	0.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	802838	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	124324	15.5%
3	97522	12.1%
1	96591	12.0%
2	85369	10.6%
5	80945	10.1%
6	77731	9.7%
7	73540	9.2%
4	60015	7.5%
8	50674	6.3%
9	48897	6.1%
Other values (9)	7230	0.9%

Lot
Text

Distinct	1055
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	12.9 MiB

Length

Max length	4
Median length	3
Mean length	3.0798793
Min length	3

Characters and Unicode

Total characters	612588
Distinct characters	36
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	180 ?
Unique (%)	0.1%

Sample

1st row	001
2nd row	017A
3rd row	027
4th row	005
5th row	051A

Value	Count	Frequency (%)
001	10114	5.1%
007	5317	2.7%
002	5183	2.6%
003	5042	2.5%
006	4835	2.4%
008	4773	2.4%
009	4590	2.3%
005	4549	2.3%
004	4384	2.2%
011	4238	2.1%
Other values (1045)	145875	73.3%

Most occurring characters

Value	Count	Frequency (%)
0	266808	43.6%
1	80408	13.1%
2	59432	9.7%
3	43025	7.0%
4	33217	5.4%
5	26862	4.4%
6	25006	4.1%
7	22210	3.6%
8	20304	3.3%
9	19441	3.2%
Other values (26)	15875	2.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	612588	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	266808	43.6%
1	80408	13.1%
2	59432	9.7%
3	43025	7.0%
4	33217	5.4%
5	26862	4.4%
6	25006	4.1%
7	22210	3.6%
8	20304	3.3%
9	19441	3.2%
Other values (26)	15875	2.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	612588	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	266808	43.6%
1	80408	13.1%
2	59432	9.7%
3	43025	7.0%
4	33217	5.4%
5	26862	4.4%
6	25006	4.1%
7	22210	3.6%
8	20304	3.3%
9	19441	3.2%
Other values (26)	15875	2.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	612588	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	266808	43.6%
1	80408	13.1%
2	59432	9.7%
3	43025	7.0%
4	33217	5.4%
5	26862	4.4%
6	25006	4.1%
7	22210	3.6%
8	20304	3.3%
9	19441	3.2%
Other values (26)	15875	2.6%

Street Number
Real number (ℝ)

Distinct	5099
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.13353916

Minimum	0
Maximum	1
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0.0038095238
Q1	0.02797619
median	0.08452381
Q3	0.20238095
95-th percentile	0.41440476
Maximum	1
Range	1
Interquartile range (IQR)	0.17440476

Descriptive statistics

Standard deviation	0.13521059
Coefficient of variation (CV)	1.0125164
Kurtosis	2.134618
Mean	0.13353916
Median Absolute Deviation (MAD)	0.069047619
Skewness	1.4268475
Sum	26560.939
Variance	0.018281903
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.000119047619	2394	1.2%
0.01202380952	1153	0.6%
0.0119047619	1143	0.6%
0.005952380952	1103	0.6%
0.02392857143	1026	0.5%
0.06607142857	994	0.5%
0.0002380952381	814	0.4%
0.006547619048	734	0.4%
0.04166666667	705	0.4%
0.01785714286	672	0.3%
Other values (5089)	188162	94.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	< 0.1%
0.000119047619	2394	1.2%
0.0002380952381	814	0.4%
0.0003571428571	309	0.2%
0.0004761904762	255	0.1%
0.0005952380952	194	0.1%
0.0007142857143	113	0.1%
0.0008333333333	132	0.1%
0.0009523809524	281	0.1%
0.001071428571	128	0.1%

Value	Count	Frequency (%)
1	3	< 0.1%
0.9917857143	1	< 0.1%
0.9910714286	5	< 0.1%
0.9904761905	1	< 0.1%
0.9880952381	1	< 0.1%
0.981547619	1	< 0.1%
0.9798809524	1	< 0.1%
0.9795238095	1	< 0.1%
0.9788095238	7	< 0.1%
0.978452381	1	< 0.1%

Street Name
Text

Distinct	1704
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	13.6 MiB

Length

Max length	25
Median length	22
Mean length	6.5097185
Min length	3

Characters and Unicode

Total characters	1294783
Distinct characters	64
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	107 ?
Unique (%)	0.1%

Sample

1st row	Jones
2nd row	43Rd
3rd row	Prentiss
4th row	Bush
5th row	Capp

Value	Count	Frequency (%)
market	5443	2.6%
california	4587	2.2%
mission	4324	2.0%
montgomery	2933	1.4%
geary	1966	0.9%
20th	1859	0.9%
03rd	1819	0.9%
folsom	1776	0.8%
van	1697	0.8%
pine	1677	0.8%
Other values (1705)	184669	86.8%

Most occurring characters

Value	Count	Frequency (%)
a	120375	9.3%
e	105510	8.1%
o	94415	7.3%
r	92518	7.1%
n	88438	6.8%
i	67764	5.2%
t	63534	4.9%
l	58445	4.5%
s	54238	4.2%
h	47210	3.6%
Other values (54)	502336	38.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1294783	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	120375	9.3%
e	105510	8.1%
o	94415	7.3%
r	92518	7.1%
n	88438	6.8%
i	67764	5.2%
t	63534	4.9%
l	58445	4.5%
s	54238	4.2%
h	47210	3.6%
Other values (54)	502336	38.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1294783	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	120375	9.3%
e	105510	8.1%
o	94415	7.3%
r	92518	7.1%
n	88438	6.8%
i	67764	5.2%
t	63534	4.9%
l	58445	4.5%
s	54238	4.2%
h	47210	3.6%
Other values (54)	502336	38.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1294783	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	120375	9.3%
e	105510	8.1%
o	94415	7.3%
r	92518	7.1%
n	88438	6.8%
i	67764	5.2%
t	63534	4.9%
l	58445	4.5%
s	54238	4.2%
h	47210	3.6%
Other values (54)	502336	38.8%

Street Suffix
Categorical

IMBALANCE

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.7 MiB

St	141126
Av	43219
Bl	3555
Wy	3540
Dr	3267
Other values (16)	4193

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	397800
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	St
2nd row	Av
3rd row	St
4th row	St
5th row	St

Common Values

Value	Count	Frequency (%)
St	141126	71.0%
Av	43219	21.7%
Bl	3555	1.8%
Wy	3540	1.8%
Dr	3267	1.6%
Tr	1466	0.7%
Ct	667	0.3%
Pl	538	0.3%
Rd	389	0.2%
Ln	354	0.2%
Other values (11)	779	0.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
st	141126	71.0%
av	43219	21.7%
bl	3555	1.8%
wy	3540	1.8%
dr	3267	1.6%
tr	1466	0.7%
ct	667	0.3%
pl	538	0.3%
rd	389	0.2%
ln	354	0.2%
Other values (11)	779	0.4%

Most occurring characters

Value	Count	Frequency (%)
t	141793	35.6%
S	141130	35.5%
A	43302	10.9%
v	43219	10.9%
r	4830	1.2%
l	4177	1.1%
y	3780	1.0%
B	3555	0.9%
W	3549	0.9%
D	3267	0.8%
Other values (13)	5198	1.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	397800	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	141793	35.6%
S	141130	35.5%
A	43302	10.9%
v	43219	10.9%
r	4830	1.2%
l	4177	1.1%
y	3780	1.0%
B	3555	0.9%
W	3549	0.9%
D	3267	0.8%
Other values (13)	5198	1.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	397800	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	141793	35.6%
S	141130	35.5%
A	43302	10.9%
v	43219	10.9%
r	4830	1.2%
l	4177	1.1%
y	3780	1.0%
B	3555	0.9%
W	3549	0.9%
D	3267	0.8%
Other values (13)	5198	1.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	397800	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	141793	35.6%
S	141130	35.5%
A	43302	10.9%
v	43219	10.9%
r	4830	1.2%
l	4177	1.1%
y	3780	1.0%
B	3555	0.9%
W	3549	0.9%
D	3267	0.8%
Other values (13)	5198	1.3%

Unit
Real number (ℝ)

SKEWED ZEROS

Distinct	661
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0019625735

Minimum	0
Maximum	1
Zeros	169421
Zeros (%)	85.2%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.00016652789
Maximum	1
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.021483994
Coefficient of variation (CV)	10.946848
Kurtosis	621.62611
Mean	0.0019625735
Median Absolute Deviation (MAD)	0
Skewness	21.144439
Sum	390.35587
Variance	0.00046156201
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	169421	85.2%
0.0001665278934	21410	10.8%
0.0003330557868	1312	0.7%
0.0004995836803	549	0.3%
0.0006661115737	448	0.2%
0.01698584513	365	0.2%
0.0008326394671	288	0.1%
0.001165695254	214	0.1%
0.0009991673605	211	0.1%
0.03363863447	210	0.1%
Other values (651)	4472	2.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	169421	85.2%
0.0001665278934	21410	10.8%
0.0003330557868	1312	0.7%
0.0004995836803	549	0.3%
0.0006661115737	448	0.2%
0.0008326394671	288	0.1%
0.0009991673605	211	0.1%
0.001165695254	214	0.1%
0.001332223147	103	0.1%
0.001498751041	104	0.1%

Value	Count	Frequency (%)
1	1	< 0.1%
0.9998334721	3	< 0.1%
0.9831806828	1	< 0.1%
0.9333888426	1	< 0.1%
0.9330557868	1	< 0.1%
0.901582015	1	< 0.1%
0.9014154871	1	< 0.1%
0.8849292256	1	< 0.1%
0.8847626978	1	< 0.1%
0.8837635304	1	< 0.1%

Description
Text

Distinct	134273
Distinct (%)	67.5%
Missing	0
Missing (%)	0.0%
Memory size	31.6 MiB

Length

Max length	300
Median length	243
Mean length	101.3254
Min length	1

Characters and Unicode

Total characters	20153622
Distinct characters	77
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	122040 ?
Unique (%)	61.4%

Sample

1st row	street space
2nd row	remodel kitchen: replace countertop, cabinets, sink, stove, hardwood floor & lighting.
3rd row	replacement of 4 windows; 2 located in lightwell and 2 at front. replaceing existing vinyl windows with new wood-clad windows. no horizontal mullion in living room window
4th row	two kitchens & two bathrooms remodel. replace kitchen cabinets, countertops & appliances in same location. replace tub & faucet & vanity & tile in same location in both units.
5th row	reroofing

Value	Count	Frequency (%)
	94912	3.0%
to	93336	2.9%
and	68890	2.2%
new	61782	1.9%
of	54700	1.7%
street	44271	1.4%
space	41098	1.3%
replace	36545	1.1%
in	36108	1.1%
for	35059	1.1%
Other values (109535)	2637168	82.3%

Most occurring characters

Value	Count	Frequency (%)
	3042970	15.1%
e	1735498	8.6%
o	1280567	6.4%
r	1278068	6.3%
t	1208498	6.0%
n	1154212	5.7%
a	1149538	5.7%
i	1122733	5.6%
s	828668	4.1%
l	785515	3.9%
Other values (67)	6567355	32.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	20153622	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	3042970	15.1%
e	1735498	8.6%
o	1280567	6.4%
r	1278068	6.3%
t	1208498	6.0%
n	1154212	5.7%
a	1149538	5.7%
i	1122733	5.6%
s	828668	4.1%
l	785515	3.9%
Other values (67)	6567355	32.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	20153622	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	3042970	15.1%
e	1735498	8.6%
o	1280567	6.4%
r	1278068	6.3%
t	1208498	6.0%
n	1154212	5.7%
a	1149538	5.7%
i	1122733	5.6%
s	828668	4.1%
l	785515	3.9%
Other values (67)	6567355	32.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	20153622	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	3042970	15.1%
e	1735498	8.6%
o	1280567	6.4%
r	1278068	6.3%
t	1208498	6.0%
n	1154212	5.7%
a	1149538	5.7%
i	1122733	5.6%
s	828668	4.1%
l	785515	3.9%
Other values (67)	6567355	32.6%

Current Status
Categorical

IMBALANCE

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	13.7 MiB

complete	97077
issued	83559
filed	12043
withdrawn	1754
cancelled	1536
Other values (9)	2931

Length

Max length	11
Median length	10
Mean length	6.9923479
Min length	5

Characters and Unicode

Total characters	1390778
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	issued
2nd row	complete
3rd row	issued
4th row	complete
5th row	issued

Common Values

Value	Count	Frequency (%)
complete	97077	48.8%
issued	83559	42.0%
filed	12043	6.1%
withdrawn	1754	0.9%
cancelled	1536	0.8%
expired	1370	0.7%
approved	733	0.4%
reinstated	563	0.3%
suspend	193	0.1%
revoked	50	< 0.1%
Other values (4)	22	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
complete	97077	48.8%
issued	83559	42.0%
filed	12043	6.1%
withdrawn	1754	0.9%
cancelled	1536	0.8%
expired	1370	0.7%
approved	733	0.4%
reinstated	563	0.3%
suspend	193	0.1%
revoked	50	< 0.1%
Other values (4)	22	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	297744	21.4%
s	168069	12.1%
l	112212	8.1%
d	101805	7.3%
c	100183	7.2%
p	100132	7.2%
t	99959	7.2%
i	99293	7.1%
o	97864	7.0%
m	97079	7.0%
Other values (10)	116438	8.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1390778	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	297744	21.4%
s	168069	12.1%
l	112212	8.1%
d	101805	7.3%
c	100183	7.2%
p	100132	7.2%
t	99959	7.2%
i	99293	7.1%
o	97864	7.0%
m	97079	7.0%
Other values (10)	116438	8.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1390778	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	297744	21.4%
s	168069	12.1%
l	112212	8.1%
d	101805	7.3%
c	100183	7.2%
p	100132	7.2%
t	99959	7.2%
i	99293	7.1%
o	97864	7.0%
m	97079	7.0%
Other values (10)	116438	8.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1390778	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	297744	21.4%
s	168069	12.1%
l	112212	8.1%
d	101805	7.3%
c	100183	7.2%
p	100132	7.2%
t	99959	7.2%
i	99293	7.1%
o	97864	7.0%
m	97079	7.0%
Other values (10)	116438	8.4%

Current Status Date
Date

Distinct	1307
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

Minimum	2013-01-02 00:00:00
Maximum	2019-02-03 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Filed Date
Date

Distinct	1288
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

Minimum	2013-01-02 00:00:00
Maximum	2018-12-02 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Issued Date
Date

Distinct	1289
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

Minimum	2013-01-02 00:00:00
Maximum	2018-12-02 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Completed Date
Date

MISSING

Distinct	514
Distinct (%)	0.4%
Missing	59463
Missing (%)	29.9%
Memory size	3.0 MiB

Minimum	1900-01-01 00:00:00
Maximum	2018-02-12 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

First Construction Document Date
Date

Distinct	1289
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

Minimum	1900-01-01 00:00:00
Maximum	2018-12-02 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Structural Notification
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

False	191978
True	6922

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	191978	96.5%
True	6922	3.5%

Number of Existing Stories
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	63
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.066624473

Minimum	0
Maximum	1
Zeros	42784
Zeros (%)	21.5%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.025316456
median	0.037974684
Q3	0.050632911
95-th percentile	0.30379747
Maximum	1
Range	1
Interquartile range (IQR)	0.025316456

Descriptive statistics

Standard deviation	0.10269932
Coefficient of variation (CV)	1.5414654
Kurtosis	13.677226
Mean	0.066624473
Median Absolute Deviation (MAD)	0.012658228
Skewness	3.5147885
Sum	13251.608
Variance	0.010547151
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.03797468354	52769	26.5%
0.05063291139	45740	23.0%
0	42784	21.5%
0.06329113924	16055	8.1%
0.0253164557	8794	4.4%
0.07594936709	3767	1.9%
0.08860759494	3696	1.9%
0.1012658228	2358	1.2%
0.1139240506	1731	0.9%
0.1265822785	1264	0.6%
Other values (53)	19942	10.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	42784	21.5%
0.01265822785	442	0.2%
0.0253164557	8794	4.4%
0.03797468354	52769	26.5%
0.05063291139	45740	23.0%
0.06329113924	16055	8.1%
0.07594936709	3767	1.9%
0.08860759494	3696	1.9%
0.1012658228	2358	1.2%
0.1139240506	1731	0.9%

Value	Count	Frequency (%)
1	1	< 0.1%
0.8101265823	99	< 0.1%
0.7974683544	2	< 0.1%
0.7848101266	24	< 0.1%
0.7721518987	18	< 0.1%
0.746835443	93	< 0.1%
0.7215189873	4	< 0.1%
0.7088607595	14	< 0.1%
0.6962025316	7	< 0.1%
0.6835443038	12	< 0.1%

Number of Proposed Stories
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	63
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.068513024

Minimum	0
Maximum	1
Zeros	39374
Zeros (%)	19.8%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.037974684
median	0.037974684
Q3	0.063291139
95-th percentile	0.30379747
Maximum	1
Range	1
Interquartile range (IQR)	0.025316456

Descriptive statistics

Standard deviation	0.10338426
Coefficient of variation (CV)	1.5089723
Kurtosis	13.559891
Mean	0.068513024
Median Absolute Deviation (MAD)	0.012658228
Skewness	3.4995812
Sum	13627.241
Variance	0.010688305
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.03797468354	51874	26.1%
0.05063291139	47248	23.8%
0	39374	19.8%
0.06329113924	17889	9.0%
0.0253164557	8638	4.3%
0.07594936709	4199	2.1%
0.08860759494	3988	2.0%
0.1012658228	2423	1.2%
0.1139240506	1802	0.9%
0.1265822785	1397	0.7%
Other values (53)	20068	10.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	39374	19.8%
0.01265822785	175	0.1%
0.0253164557	8638	4.3%
0.03797468354	51874	26.1%
0.05063291139	47248	23.8%
0.06329113924	17889	9.0%
0.07594936709	4199	2.1%
0.08860759494	3988	2.0%
0.1012658228	2423	1.2%
0.1139240506	1802	0.9%

Value	Count	Frequency (%)
1	1	< 0.1%
0.8101265823	113	0.1%
0.7974683544	4	< 0.1%
0.7848101266	24	< 0.1%
0.7721518987	19	< 0.1%
0.746835443	93	< 0.1%
0.7215189873	11	< 0.1%
0.7088607595	23	< 0.1%
0.6962025316	14	< 0.1%
0.6835443038	12	< 0.1%

Voluntary Soft-Story Retrofit
Boolean

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

False	198865
True	35

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	198865	> 99.9%
True	35	< 0.1%

Fire Only Permit
Boolean

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

False	180073
True	18827

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	180073	90.5%
True	18827	9.5%

Permit Expiration Date
Date

Distinct	2232
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

Minimum	2013-07-10 00:00:00
Maximum	2024-11-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Estimated Cost
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	11395
Distinct (%)	5.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.00035124895

Minimum	0
Maximum	1
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	0
5-th percentile	2.7846007 × 10^-6
Q1	1.4867314 × 10^-5
median	5.5762651 × 10^-5
Q3	0.00035132925
95-th percentile	0.00037177207
Maximum	1
Range	1
Interquartile range (IQR)	0.00033646194

Descriptive statistics

Standard deviation	0.0060676363
Coefficient of variation (CV)	17.274461
Kurtosis	11025.015
Mean	0.00035124895
Median Absolute Deviation (MAD)	5.1676835 × 10^-5
Skewness	89.2783
Sum	69.863416
Variance	3.6816211 × 10^-5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0003513292513	55080	27.7%
1.858507176 × 10^-5	6695	3.4%
9.290676999 × 10^-6	6437	3.2%
3.717386127 × 10^-5	5702	2.9%
2.787946651 × 10^-5	4779	2.4%
5.576265078 × 10^-5	3939	2.0%
4.646825602 × 10^-5	3599	1.8%
5.572919096 × 10^-6	3568	1.8%
9.294022981 × 10^-5	3345	1.7%
3.714040145 × 10^-6	3203	1.6%
Other values (11385)	102553	51.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
3.717757903 × 10^-9	2	< 0.1%
5.576636854 × 10^-9	3	< 0.1%
1.487103161 × 10^-8	11	< 0.1%
3.345982112 × 10^-8	5	< 0.1%
4.275421588 × 10^-8	7	< 0.1%
5.204861064 × 10^-8	3	< 0.1%
6.134300539 × 10^-8	1	< 0.1%
7.063740015 × 10^-8	1	< 0.1%
8.922618966 × 10^-8	41	< 0.1%

Value	Count	Frequency (%)
1	1	< 0.1%
0.966617051	1	< 0.1%
0.7435515768	2	< 0.1%
0.6320188397	1	< 0.1%
0.505615071	1	< 0.1%
0.5018973131	1	< 0.1%
0.4442720656	1	< 0.1%
0.3903645761	1	< 0.1%
0.3253038128	1	< 0.1%
0.3104327811	2	< 0.1%

Revised Cost
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	12869
Distinct (%)	6.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.00027286707

Minimum	0
Maximum	1
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	0
5-th percentile	1.9218322 × 10^-6
Q1	1.1531057 × 10^-5
median	4.9566931 × 10^-5
Q3	0.00027292126
95-th percentile	0.00032030748
Maximum	1
Range	1
Interquartile range (IQR)	0.0002613902

Descriptive statistics

Standard deviation	0.004678797
Coefficient of variation (CV)	17.146799
Kurtosis	15377.16
Mean	0.00027286707
Median Absolute Deviation (MAD)	4.6525304 × 10^-5
Skewness	100.95908
Sum	54.273261
Variance	2.1891141 × 10^-5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0002729212582	55741	28.0%
1.2812287 × 10^-5	5663	2.8%
6.406137092 × 10^-6	5645	2.8%
2.56245868 × 10^-5	4902	2.5%
1.92184369 × 10^-5	4144	2.1%
3.843688661 × 10^-5	3413	1.7%
3.203073671 × 10^-5	3259	1.6%
3.84367713 × 10^-6	3144	1.6%
2.562447149 × 10^-6	3031	1.5%
6.406148623 × 10^-5	3018	1.5%
Other values (12859)	106940	53.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1.524663677 × 10^-9	1	< 0.1%
2.549647662 × 10^-9	4	< 0.1%
6.393337604 × 10^-9	4	< 0.1%
1.279948751 × 10^-8	14	< 0.1%
1.536194747 × 10^-8	1	< 0.1%
1.664317745 × 10^-8	1	< 0.1%
1.792440743 × 10^-8	6	< 0.1%
2.561178732 × 10^-8	17	< 0.1%
3.201793722 × 10^-8	6	< 0.1%

Value	Count	Frequency (%)
1	1	< 0.1%
0.66623959	1	< 0.1%
0.5124919923	2	< 0.1%
0.4307495195	1	< 0.1%
0.3459320948	1	< 0.1%
0.3408859526	1	< 0.1%
0.3062139654	1	< 0.1%
0.269058296	1	< 0.1%
0.2660858424	1	< 0.1%
0.2562459961	4	< 0.1%

Existing Use
Text

Distinct	94
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.8 MiB

Length

Max length	30
Median length	27
Mean length	12.781508
Min length	4

Characters and Unicode

Total characters	2542242
Distinct characters	39
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	Desconocido
2nd row	1 family dwelling
3rd row	1 family dwelling
4th row	2 family dwelling
5th row	apartments

Value	Count	Frequency (%)
family	67753	19.0%
dwelling	67753	19.0%
1	46766	13.1%
desconocido	41114	11.5%
apartments	40798	11.4%
office	24616	6.9%
2	20987	5.9%
sales	7032	2.0%
retail	6910	1.9%
food/beverage	4886	1.4%
Other values (140)	28914	8.1%

Most occurring characters

Value	Count	Frequency (%)
l	235958	9.3%
i	221886	8.7%
e	220229	8.7%
a	187975	7.4%
o	173288	6.8%
n	171228	6.7%
	158629	6.2%
f	123921	4.9%
d	122543	4.8%
c	114773	4.5%
Other values (29)	811812	31.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2542242	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	235958	9.3%
i	221886	8.7%
e	220229	8.7%
a	187975	7.4%
o	173288	6.8%
n	171228	6.7%
	158629	6.2%
f	123921	4.9%
d	122543	4.8%
c	114773	4.5%
Other values (29)	811812	31.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2542242	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	235958	9.3%
i	221886	8.7%
e	220229	8.7%
a	187975	7.4%
o	173288	6.8%
n	171228	6.7%
	158629	6.2%
f	123921	4.9%
d	122543	4.8%
c	114773	4.5%
Other values (29)	811812	31.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2542242	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	235958	9.3%
i	221886	8.7%
e	220229	8.7%
a	187975	7.4%
o	173288	6.8%
n	171228	6.7%
	158629	6.2%
f	123921	4.9%
d	122543	4.8%
c	114773	4.5%
Other values (29)	811812	31.9%

Existing Units
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	348
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0062223069

Minimum	0
Maximum	1
Zeros	29134
Zeros (%)	14.6%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.00052438385
median	0.00052438385
Q3	0.0010487677
95-th percentile	0.022024122
Maximum	1
Range	1
Interquartile range (IQR)	0.00052438385

Descriptive statistics

Standard deviation	0.033784195
Coefficient of variation (CV)	5.4295289
Kurtosis	319.74268
Mean	0.0062223069
Median Absolute Deviation (MAD)	0.00052438385
Skewness	14.90048
Sum	1237.6168
Variance	0.0011413718
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.000524383849	98884	49.7%
0	29134	14.6%
0.001048767698	21804	11.0%
0.001573151547	8616	4.3%
0.003146303094	6066	3.0%
0.002097535396	5364	2.7%
0.006292606188	2535	1.3%
0.002621919245	2347	1.2%
0.004195070792	1728	0.9%
0.004719454641	1188	0.6%
Other values (338)	21234	10.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	29134	14.6%
0.0001573151547	1	< 0.1%
0.000524383849	98884	49.7%
0.001048767698	21804	11.0%
0.001573151547	8616	4.3%
0.002097535396	5364	2.7%
0.002621919245	2347	1.2%
0.003146303094	6066	3.0%
0.003670686943	1172	0.6%
0.004195070792	1728	0.9%

Value	Count	Frequency (%)
1	44	< 0.1%
0.9082328264	8	< 0.1%
0.7865757735	51	< 0.1%
0.7860513896	1	< 0.1%
0.6219192449	51	< 0.1%
0.5296276875	2	< 0.1%
0.5270057682	21	< 0.1%
0.5264813844	2	< 0.1%
0.524383849	1	< 0.1%
0.4971158888	1	< 0.1%

Proposed Use
Text

Distinct	104
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.8 MiB

Length

Max length	30
Median length	23
Mean length	12.796802
Min length	4

Characters and Unicode

Total characters	2545284
Distinct characters	40
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	Desconocido
2nd row	1 family dwelling
3rd row	1 family dwelling
4th row	2 family dwelling
5th row	apartments

Value	Count	Frequency (%)
family	68632	19.1%
dwelling	68632	19.1%
1	46529	13.0%
apartments	43279	12.1%
desconocido	38804	10.8%
office	24523	6.8%
2	22103	6.2%
sales	6264	1.7%
retail	6126	1.7%
food/beverage	5660	1.6%
Other values (152)	28140	7.8%

Most occurring characters

Value	Count	Frequency (%)
l	236566	9.3%
e	221201	8.7%
i	220114	8.6%
a	185143	7.3%
n	172023	6.8%
o	166773	6.6%
	159792	6.3%
f	125224	4.9%
d	123162	4.8%
m	117066	4.6%
Other values (30)	818220	32.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2545284	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	236566	9.3%
e	221201	8.7%
i	220114	8.6%
a	185143	7.3%
n	172023	6.8%
o	166773	6.6%
	159792	6.3%
f	125224	4.9%
d	123162	4.8%
m	117066	4.6%
Other values (30)	818220	32.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2545284	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	236566	9.3%
e	221201	8.7%
i	220114	8.6%
a	185143	7.3%
n	172023	6.8%
o	166773	6.6%
	159792	6.3%
f	125224	4.9%
d	123162	4.8%
m	117066	4.6%
Other values (30)	818220	32.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2545284	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	236566	9.3%
e	221201	8.7%
i	220114	8.6%
a	185143	7.3%
n	172023	6.8%
o	166773	6.6%
	159792	6.3%
f	125224	4.9%
d	123162	4.8%
m	117066	4.6%
Other values (30)	818220	32.1%

Proposed Units
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	370
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0067083717

Minimum	0
Maximum	1
Zeros	28632
Zeros (%)	14.4%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.00052328624
median	0.00052328624
Q3	0.0015698587
95-th percentile	0.025117739
Maximum	1
Range	1
Interquartile range (IQR)	0.0010465725

Descriptive statistics

Standard deviation	0.034679413
Coefficient of variation (CV)	5.1695724
Kurtosis	286.96287
Mean	0.0067083717
Median Absolute Deviation (MAD)	0.00052328624
Skewness	13.987626
Sum	1334.2951
Variance	0.0012026617
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0005232862376	95596	48.1%
0	28632	14.4%
0.001046572475	22943	11.5%
0.001569858713	9371	4.7%
0.003139717425	5903	3.0%
0.00209314495	5530	2.8%
0.006279434851	2477	1.2%
0.002616431188	2402	1.2%
0.004186289901	1811	0.9%
0.003663003663	1339	0.7%
Other values (360)	22896	11.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	28632	14.4%
0.0005232862376	95596	48.1%
0.001046572475	22943	11.5%
0.001569858713	9371	4.7%
0.00209314495	5530	2.8%
0.002616431188	2402	1.2%
0.003139717425	5903	3.0%
0.003663003663	1339	0.7%
0.004186289901	1811	0.9%
0.004709576138	1275	0.6%

Value	Count	Frequency (%)
1	1	< 0.1%
0.997906855	43	< 0.1%
0.9063317635	8	< 0.1%
0.7849293564	51	< 0.1%
0.7844060701	1	< 0.1%
0.6274201988	1	< 0.1%
0.6206174778	50	< 0.1%
0.5306122449	4	< 0.1%
0.5285190999	2	< 0.1%
0.5259026688	19	< 0.1%

Plansets
Real number (ℝ)

MISSING SKEWED ZEROS

Distinct	8
Distinct (%)	< 0.1%
Missing	37309
Missing (%)	18.8%
Infinite	0
Infinite (%)	0.0%
Mean	1.2746502

Minimum	0
Maximum	9000
Zeros	63244
Zeros (%)	31.8%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	2
95-th percentile	2
Maximum	9000
Range	9000
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	22.407345
Coefficient of variation (CV)	17.579211
Kurtosis	160974.06
Mean	1.2746502
Median Absolute Deviation (MAD)	0
Skewness	400.83221
Sum	205972
Variance	502.08913
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2	98088	49.3%
0	63244	31.8%
3	250	0.1%
4	3	< 0.1%
6	2	< 0.1%
1	2	< 0.1%
20	1	< 0.1%
9000	1	< 0.1%
(Missing)	37309	18.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	63244	31.8%
1	2	< 0.1%
2	98088	49.3%
3	250	0.1%
4	3	< 0.1%
6	2	< 0.1%
20	1	< 0.1%
9000	1	< 0.1%

Value	Count	Frequency (%)
9000	1	< 0.1%
20	1	< 0.1%
6	2	< 0.1%
4	3	< 0.1%
3	250	0.1%
2	98088	49.3%
1	2	< 0.1%
0	63244	31.8%

TIDF Compliance
Boolean

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

False	198898
True	2

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	198898	> 99.9%
True	2	< 0.1%

Existing Construction Type
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.4695073

Minimum	-99999
Maximum	99999
Zeros	0
Zeros (%)	0.0%
Negative	43367
Negative (%)	21.8%
Memory size	3.0 MiB

Quantile statistics

Minimum	-99999
5-th percentile	-1
Q1	1
median	5
Q3	5
95-th percentile	5
Maximum	99999
Range	199998
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	501.38005
Coefficient of variation (CV)	144.51045
Kurtosis	39775.909
Mean	3.4695073
Median Absolute Deviation (MAD)	0
Skewness	39.868647
Sum	690085
Variance	251381.96
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
5	113346	57.0%
-1	43365	21.8%
1	28072	14.1%
3	9663	4.9%
2	4068	2.0%
4	381	0.2%
99999	3	< 0.1%
-99999	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-99999	2	< 0.1%
-1	43365	21.8%
1	28072	14.1%
2	4068	2.0%
3	9663	4.9%
4	381	0.2%
5	113346	57.0%
99999	3	< 0.1%

Value	Count	Frequency (%)
99999	3	< 0.1%
5	113346	57.0%
4	381	0.2%
3	9663	4.9%
2	4068	2.0%
1	28072	14.1%
-1	43365	21.8%
-99999	2	< 0.1%

Existing Construction Type Description
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.9 MiB

wood frame (5)	113350
NON AVAILABLE	43366
constr type 1	28072
constr type 3	9663
constr type 2	4068

Length

Max length	14
Median length	14
Mean length	13.569884
Min length	13

Characters and Unicode

Total characters	2699050
Distinct characters	30
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NON AVAILABLE
2nd row	wood frame (5)
3rd row	wood frame (5)
4th row	wood frame (5)
5th row	wood frame (5)

Common Values

Value	Count	Frequency (%)
wood frame (5)	113350	57.0%
NON AVAILABLE	43366	21.8%
constr type 1	28072	14.1%
constr type 3	9663	4.9%
constr type 2	4068	2.0%
constr type 4	381	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
wood	113350	20.5%
frame	113350	20.5%
5	113350	20.5%
non	43366	7.8%
available	43366	7.8%
constr	42184	7.6%
type	42184	7.6%
1	28072	5.1%
3	9663	1.7%
2	4068	0.7%

Most occurring characters

Value	Count	Frequency (%)
	354434	13.1%
o	268884	10.0%
e	155534	5.8%
r	155534	5.8%
A	130098	4.8%
w	113350	4.2%
)	113350	4.2%
5	113350	4.2%
(	113350	4.2%
m	113350	4.2%
Other values (20)	1067816	39.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2699050	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	354434	13.1%
o	268884	10.0%
e	155534	5.8%
r	155534	5.8%
A	130098	4.8%
w	113350	4.2%
)	113350	4.2%
5	113350	4.2%
(	113350	4.2%
m	113350	4.2%
Other values (20)	1067816	39.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2699050	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	354434	13.1%
o	268884	10.0%
e	155534	5.8%
r	155534	5.8%
A	130098	4.8%
w	113350	4.2%
)	113350	4.2%
5	113350	4.2%
(	113350	4.2%
m	113350	4.2%
Other values (20)	1067816	39.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2699050	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	354434	13.1%
o	268884	10.0%
e	155534	5.8%
r	155534	5.8%
A	130098	4.8%
w	113350	4.2%
)	113350	4.2%
5	113350	4.2%
(	113350	4.2%
m	113350	4.2%
Other values (20)	1067816	39.6%

Proposed Construction Type
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.985083

Minimum	-1
Maximum	5
Zeros	0
Zeros (%)	0.0%
Negative	43162
Negative (%)	21.7%
Memory size	3.0 MiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	1
median	5
Q3	5
95-th percentile	5
Maximum	5
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.5205052
Coefficient of variation (CV)	0.8443669
Kurtosis	-1.3547659
Mean	2.985083
Median Absolute Deviation (MAD)	0
Skewness	-0.63327424
Sum	593733
Variance	6.3529467
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
5	114382	57.5%
-1	43162	21.7%
1	27841	14.0%
3	9360	4.7%
2	3778	1.9%
4	377	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	43162	21.7%
1	27841	14.0%
2	3778	1.9%
3	9360	4.7%
4	377	0.2%
5	114382	57.5%

Value	Count	Frequency (%)
5	114382	57.5%
4	377	0.2%
3	9360	4.7%
2	3778	1.9%
1	27841	14.0%
-1	43162	21.7%

Proposed Construction Type Description
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.9 MiB

wood frame (5)	114382
NON AVAILABLE	43162
constr type 1	27841
constr type 3	9360
constr type 2	3778

Length

Max length	14
Median length	14
Mean length	13.575073
Min length	13

Characters and Unicode

Total characters	2700082
Distinct characters	30
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NON AVAILABLE
2nd row	wood frame (5)
3rd row	wood frame (5)
4th row	wood frame (5)
5th row	wood frame (5)

Common Values

Value	Count	Frequency (%)
wood frame (5)	114382	57.5%
NON AVAILABLE	43162	21.7%
constr type 1	27841	14.0%
constr type 3	9360	4.7%
constr type 2	3778	1.9%
constr type 4	377	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
wood	114382	20.7%
frame	114382	20.7%
5	114382	20.7%
non	43162	7.8%
available	43162	7.8%
constr	41356	7.5%
type	41356	7.5%
1	27841	5.0%
3	9360	1.7%
2	3778	0.7%

Most occurring characters

Value	Count	Frequency (%)
	354638	13.1%
o	270120	10.0%
e	155738	5.8%
r	155738	5.8%
A	129486	4.8%
w	114382	4.2%
)	114382	4.2%
5	114382	4.2%
(	114382	4.2%
m	114382	4.2%
Other values (20)	1062452	39.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2700082	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	354638	13.1%
o	270120	10.0%
e	155738	5.8%
r	155738	5.8%
A	129486	4.8%
w	114382	4.2%
)	114382	4.2%
5	114382	4.2%
(	114382	4.2%
m	114382	4.2%
Other values (20)	1062452	39.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2700082	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	354638	13.1%
o	270120	10.0%
e	155738	5.8%
r	155738	5.8%
A	129486	4.8%
w	114382	4.2%
)	114382	4.2%
5	114382	4.2%
(	114382	4.2%
m	114382	4.2%
Other values (20)	1062452	39.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2700082	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	354638	13.1%
o	270120	10.0%
e	155738	5.8%
r	155738	5.8%
A	129486	4.8%
w	114382	4.2%
)	114382	4.2%
5	114382	4.2%
(	114382	4.2%
m	114382	4.2%
Other values (20)	1062452	39.3%

Site Permit
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

False	193541
True	5359

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	193541	97.3%
True	5359	2.7%

Supervisor District
Real number (ℝ)

HIGH CORRELATION

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.4820312

Minimum	-1
Maximum	20
Zeros	0
Zeros (%)	0.0%
Negative	1719
Negative (%)	0.9%
Memory size	3.0 MiB

Quantile statistics

Minimum	-1
5-th percentile	1
Q1	3
median	6
Q3	8
95-th percentile	10
Maximum	20
Range	21
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.937832
Coefficient of variation (CV)	0.53590209
Kurtosis	-1.0840767
Mean	5.4820312
Median Absolute Deviation (MAD)	3
Skewness	0.058411973
Sum	1090376
Variance	8.6308568
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
3	28648	14.4%
8	26760	13.5%
2	25483	12.8%
6	24795	12.5%
5	19044	9.6%
9	16361	8.2%
7	14365	7.2%
1	13038	6.6%
10	12153	6.1%
4	9592	4.8%
Other values (4)	8661	4.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	1719	0.9%
1	13038	6.6%
2	25483	12.8%
3	28648	14.4%
4	9592	4.8%
5	19044	9.6%
6	24795	12.5%
7	14365	7.2%
8	26760	13.5%
9	16361	8.2%

Value	Count	Frequency (%)
20	1	< 0.1%
15	1	< 0.1%
11	6940	3.5%
10	12153	6.1%
9	16361	8.2%
8	26760	13.5%
7	14365	7.2%
6	24795	12.5%
5	19044	9.6%
4	9592	4.8%

Neighborhoods - Analysis Boundaries
Categorical

HIGH CORRELATION

Distinct	42
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.1 MiB

Financial District/South Beach	21816
Mission	14681
Sunset/Parkside	10207
West of Twin Peaks	8739
Castro/Upper Market	8527
Other values (37)	134930

Length

Max length	30
Median length	18
Mean length	14.765591
Min length	6

Characters and Unicode

Total characters	2936876
Distinct characters	46
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Nob Hill
2nd row	Sunset/Parkside
3rd row	Bernal Heights
4th row	Pacific Heights
5th row	Mission

Common Values

Value	Count	Frequency (%)
Financial District/South Beach	21816	11.0%
Mission	14681	7.4%
Sunset/Parkside	10207	5.1%
West of Twin Peaks	8739	4.4%
Castro/Upper Market	8527	4.3%
Pacific Heights	8508	4.3%
Marina	8244	4.1%
Outer Richmond	7854	3.9%
Noe Valley	7844	3.9%
South of Market	7572	3.8%
Other values (32)	94908	47.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
beach	25870	6.5%
financial	21816	5.5%
district/south	21816	5.5%
mission	19210	4.8%
heights	18659	4.7%
of	16311	4.1%
market	16099	4.0%
hill	15797	4.0%
valley	14233	3.6%
richmond	12312	3.1%
Other values (48)	216386	54.3%

Most occurring characters

Value	Count	Frequency (%)
i	281022	9.6%
e	234489	8.0%
a	203688	6.9%
	199609	6.8%
n	198628	6.8%
t	194560	6.6%
s	176836	6.0%
o	150135	5.1%
r	148180	5.0%
c	109197	3.7%
Other values (36)	1040532	35.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2936876	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	281022	9.6%
e	234489	8.0%
a	203688	6.9%
	199609	6.8%
n	198628	6.8%
t	194560	6.6%
s	176836	6.0%
o	150135	5.1%
r	148180	5.0%
c	109197	3.7%
Other values (36)	1040532	35.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2936876	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	281022	9.6%
e	234489	8.0%
a	203688	6.9%
	199609	6.8%
n	198628	6.8%
t	194560	6.6%
s	176836	6.0%
o	150135	5.1%
r	148180	5.0%
c	109197	3.7%
Other values (36)	1040532	35.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2936876	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	281022	9.6%
e	234489	8.0%
a	203688	6.9%
	199609	6.8%
n	198628	6.8%
t	194560	6.6%
s	176836	6.0%
o	150135	5.1%
r	148180	5.0%
c	109197	3.7%
Other values (36)	1040532	35.4%

Zipcode
Real number (ℝ)

HIGH CORRELATION

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	93303.515

Minimum	-1
Maximum	94158
Zeros	0
Zeros (%)	0.0%
Negative	1716
Negative (%)	0.9%
Memory size	3.0 MiB

Quantile statistics

Minimum	-1
5-th percentile	94103
Q1	94109
median	94114
Q3	94122
95-th percentile	94133
Maximum	94158
Range	94159
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	8704.1587
Coefficient of variation (CV)	0.093288647
Kurtosis	110.92036
Mean	93303.515
Median Absolute Deviation (MAD)	7
Skewness	-10.62634
Sum	1.8558069 × 10¹⁰
Variance	75762379
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
94110	17837	9.0%
94114	13404	6.7%
94117	11780	5.9%
94109	11348	5.7%
94103	10986	5.5%
94115	10095	5.1%
94118	9812	4.9%
94123	9515	4.8%
94122	8886	4.5%
94105	8628	4.3%
Other values (18)	86609	43.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	1716	0.9%
94102	7164	3.6%
94103	10986	5.5%
94104	4229	2.1%
94105	8628	4.3%
94107	7706	3.9%
94108	5320	2.7%
94109	11348	5.7%
94110	17837	9.0%
94111	5385	2.7%

Value	Count	Frequency (%)
94158	1058	0.5%
94134	2983	1.5%
94133	7424	3.7%
94132	3507	1.8%
94131	7664	3.9%
94130	81	< 0.1%
94129	23	< 0.1%
94127	4993	2.5%
94124	5265	2.6%
94123	9515	4.8%

Location
Text

Distinct	57604
Distinct (%)	29.2%
Missing	1700
Missing (%)	0.9%
Memory size	19.8 MiB

Length

Max length	41
Median length	40
Mean length	40.04427
Min length	35

Characters and Unicode

Total characters	7896730
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	26166 ?
Unique (%)	13.3%

Sample

1st row	(37.79362102799777, -122.41488237355445)
2nd row	(37.759041020475465, -122.50286985467523)
3rd row	(37.73778863007536, -122.41197863877355)
4th row	(37.78762264983362, -122.43099126735969)
5th row	(37.75275550565926, -122.41707462095194)

Value	Count	Frequency (%)
37.79226164705184	554	0.1%
122.4034859571375	554	0.1%
37.79294896659241	330	0.1%
122.39809861435491	330	0.1%
37.728556952954136	281	0.1%
122.47676641508518	281	0.1%
37.77523036414975	276	0.1%
122.4174703200545	276	0.1%
37.78977799888473	252	0.1%
122.40173648131338	252	0.1%
Other values (115177)	391014	99.1%

Most occurring characters

Value	Count	Frequency (%)
2	899219	11.4%
7	893432	11.3%
3	736552	9.3%
1	703883	8.9%
4	698280	8.8%
5	534294	6.8%
6	524215	6.6%
8	524170	6.6%
9	523462	6.6%
0	478823	6.1%
Other values (6)	1380400	17.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7896730	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	899219	11.4%
7	893432	11.3%
3	736552	9.3%
1	703883	8.9%
4	698280	8.8%
5	534294	6.8%
6	524215	6.6%
8	524170	6.6%
9	523462	6.6%
0	478823	6.1%
Other values (6)	1380400	17.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7896730	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	899219	11.4%
7	893432	11.3%
3	736552	9.3%
1	703883	8.9%
4	698280	8.8%
5	534294	6.8%
6	524215	6.6%
8	524170	6.6%
9	523462	6.6%
0	478823	6.1%
Other values (6)	1380400	17.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7896730	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	899219	11.4%
7	893432	11.3%
3	736552	9.3%
1	703883	8.9%
4	698280	8.8%
5	534294	6.8%
6	524215	6.6%
8	524170	6.6%
9	523462	6.6%
0	478823	6.1%
Other values (6)	1380400	17.5%

Record ID
Real number (ℝ)

UNIQUE

Distinct	198900
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1620476 × 10¹²

Minimum	1.2935322 × 10¹⁰
Maximum	1.4983421 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	1.2935322 × 10¹⁰
5-th percentile	1.3453444 × 10¹¹
Q1	1.3085667 × 10¹²
median	1.3718398 × 10¹²
Q3	1.4349996 × 10¹²
95-th percentile	1.4859054 × 10¹²
Maximum	1.4983421 × 10¹²
Range	1.4854068 × 10¹²
Interquartile range (IQR)	1.2643288 × 10¹¹

Descriptive statistics

Standard deviation	4.9182154 × 10¹¹
Coefficient of variation (CV)	0.42323701
Kurtosis	0.55167729
Mean	1.1620476 × 10¹²
Median Absolute Deviation (MAD)	6.3217604 × 10¹⁰
Skewness	-1.5726912
Sum	2.3113126 × 10¹⁷
Variance	2.4188842 × 10²³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.464153233 × 10¹²	1	< 0.1%
1.474831103 × 10¹²	1	< 0.1%
1.472149495 × 10¹²	1	< 0.1%
1.462796863 × 10¹¹	1	< 0.1%
1.40211042 × 10¹²	1	< 0.1%
1.319225265 × 10¹²	1	< 0.1%
1.450474223 × 10¹²	1	< 0.1%
1.490112504 × 10¹²	1	< 0.1%
1.328877132 × 10¹²	1	< 0.1%
1.379653138 × 10¹²	1	< 0.1%
Other values (198890)	198890	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.29353215 × 10¹⁰	1	< 0.1%
1.295722223 × 10¹⁰	1	< 0.1%
1.296226196 × 10¹⁰	1	< 0.1%
1.296342101 × 10¹⁰	1	< 0.1%
1.296629102 × 10¹⁰	1	< 0.1%
1.297286249 × 10¹⁰	1	< 0.1%
1.297668221 × 10¹⁰	1	< 0.1%
1.297846157 × 10¹⁰	1	< 0.1%
1.298230162 × 10¹⁰	1	< 0.1%
1.298784182 × 10¹⁰	1	< 0.1%

Value	Count	Frequency (%)
1.498342128 × 10¹²	1	< 0.1%
1.498341156 × 10¹²	1	< 0.1%
1.498339194 × 10¹²	1	< 0.1%
1.498338347 × 10¹²	1	< 0.1%
1.498337117 × 10¹²	1	< 0.1%
1.498336196 × 10¹²	1	< 0.1%
1.498335409 × 10¹²	1	< 0.1%
1.498334222 × 10¹²	1	< 0.1%
1.498331399 × 10¹²	1	< 0.1%
1.498330476 × 10¹²	1	< 0.1%

Auto

Heatmap
Table

	Current Status	Estimated Cost	Existing Construction Type	Existing Construction Type Description	Existing Units	Fire Only Permit	Neighborhoods - Analysis Boundaries	Number of Existing Stories	Number of Proposed Stories	Permit Type	Permit Type Definition	Plansets	Proposed Construction Type	Proposed Construction Type Description	Proposed Units	Record ID	Revised Cost	Site Permit	Street Number	Street Suffix	Structural Notification	Supervisor District	TIDF Compliance	Unit	Voluntary Soft-Story Retrofit	Zipcode
Current Status	1.000	0.015	0.298	0.233	0.010	0.130	0.040	0.043	0.042	0.135	0.135	0.000	0.236	0.236	0.009	0.106	0.013	0.213	0.018	0.026	0.135	0.026	0.000	0.000	0.003	0.021
Estimated Cost	0.015	1.000	-0.465	0.015	-0.128	0.001	0.009	-0.295	-0.256	-0.074	0.156	0.242	-0.420	0.019	-0.113	0.012	0.904	0.117	0.017	0.000	0.011	-0.051	0.000	-0.003	0.000	-0.049
Existing Construction Type	0.298	-0.465	1.000	0.577	0.372	0.122	0.102	0.326	0.254	-0.048	0.130	-0.351	0.941	0.515	0.339	0.044	-0.416	0.005	0.075	0.031	0.098	0.096	0.000	-0.022	0.006	0.245
Existing Construction Type Description	0.233	0.015	0.577	1.000	0.115	0.394	0.361	0.374	0.368	0.122	0.122	0.000	0.942	0.942	0.107	0.079	0.012	0.076	0.100	0.122	0.155	0.191	0.000	0.051	0.010	0.052
Existing Units	0.010	-0.128	0.372	0.115	1.000	0.066	0.110	0.220	0.191	0.004	0.007	-0.198	0.372	0.113	0.965	0.047	-0.110	0.016	0.143	0.056	0.021	-0.066	0.000	0.241	0.000	0.083
Fire Only Permit	0.130	0.001	0.122	0.394	0.066	1.000	0.355	0.347	0.348	0.055	0.055	0.000	0.417	0.417	0.069	0.039	0.000	0.054	0.106	0.107	0.061	0.183	0.000	0.008	0.003	0.008
Neighborhoods - Analysis Boundaries	0.040	0.009	0.102	0.361	0.110	0.355	1.000	0.249	0.251	0.093	0.093	0.000	0.355	0.355	0.111	0.367	0.007	0.106	0.320	0.210	0.125	0.762	0.000	0.055	0.011	0.997
Number of Existing Stories	0.043	-0.295	0.326	0.374	0.220	0.347	0.249	1.000	0.947	-0.032	0.033	0.236	0.280	0.363	0.197	-0.069	-0.256	0.057	-0.121	0.083	0.068	-0.150	0.000	0.142	0.000	-0.263
Number of Proposed Stories	0.042	-0.256	0.254	0.368	0.191	0.348	0.251	0.947	1.000	-0.104	0.038	0.292	0.274	0.369	0.225	-0.063	-0.216	0.046	-0.136	0.083	0.069	-0.133	0.000	0.129	0.000	-0.269
Permit Type	0.135	-0.074	-0.048	0.122	0.004	0.055	0.093	-0.032	-0.104	1.000	1.000	-0.285	-0.029	0.144	-0.042	-0.013	-0.083	0.614	-0.005	0.058	0.396	-0.049	0.010	0.047	0.023	-0.002
Permit Type Definition	0.135	0.156	0.130	0.122	0.007	0.055	0.093	0.033	0.038	1.000	1.000	0.000	0.144	0.144	0.018	0.023	0.134	0.614	0.017	0.058	0.396	0.043	0.010	0.004	0.023	0.021
Plansets	0.000	0.242	-0.351	0.000	-0.198	0.000	0.000	0.236	0.292	-0.285	0.000	1.000	-0.342	0.000	-0.165	-0.015	0.285	0.000	-0.064	0.000	0.000	-0.052	0.000	-0.040	0.000	-0.200
Proposed Construction Type	0.236	-0.420	0.941	0.942	0.372	0.417	0.355	0.280	0.274	-0.029	0.144	-0.342	1.000	1.000	0.373	0.052	-0.370	0.111	0.059	0.124	0.155	0.114	0.000	-0.027	0.010	0.264
Proposed Construction Type Description	0.236	0.019	0.515	0.942	0.113	0.417	0.355	0.363	0.369	0.144	0.144	0.000	1.000	1.000	0.116	0.080	0.017	0.111	0.100	0.124	0.155	0.190	0.000	0.051	0.010	0.054
Proposed Units	0.009	-0.113	0.339	0.107	0.965	0.069	0.111	0.197	0.225	-0.042	0.018	-0.165	0.373	0.116	1.000	0.052	-0.094	0.003	0.136	0.056	0.021	-0.053	0.000	0.230	0.000	0.075
Record ID	0.106	0.012	0.044	0.079	0.047	0.039	0.367	-0.069	-0.063	-0.013	0.023	-0.015	0.052	0.080	0.052	1.000	0.014	0.013	-0.023	0.098	0.007	0.273	0.000	0.086	0.005	-0.005
Revised Cost	0.013	0.904	-0.416	0.012	-0.110	0.000	0.007	-0.256	-0.216	-0.083	0.134	0.285	-0.370	0.017	-0.094	0.014	1.000	0.100	0.022	0.000	0.005	-0.058	0.000	0.000	0.000	-0.050
Site Permit	0.213	0.117	0.005	0.076	0.016	0.054	0.106	0.057	0.046	0.614	0.614	0.000	0.111	0.111	0.003	0.013	0.100	1.000	0.013	0.123	0.506	0.074	0.000	0.010	0.000	0.015
Street Number	0.018	0.017	0.075	0.100	0.143	0.106	0.320	-0.121	-0.136	-0.005	0.017	-0.064	0.059	0.100	0.136	-0.023	0.022	0.013	1.000	0.119	0.020	-0.173	0.000	0.046	0.000	0.147
Street Suffix	0.026	0.000	0.031	0.122	0.056	0.107	0.210	0.083	0.083	0.058	0.058	0.000	0.124	0.124	0.056	0.098	0.000	0.123	0.119	1.000	0.057	0.183	0.000	0.029	0.018	0.037
Structural Notification	0.135	0.011	0.098	0.155	0.021	0.061	0.125	0.068	0.069	0.396	0.396	0.000	0.155	0.155	0.021	0.007	0.005	0.506	0.020	0.057	1.000	0.067	0.000	0.011	0.000	0.017
Supervisor District	0.026	-0.051	0.096	0.191	-0.066	0.183	0.762	-0.150	-0.133	-0.049	0.043	-0.052	0.114	0.190	-0.053	0.273	-0.058	0.074	-0.173	0.183	0.067	1.000	0.000	-0.122	0.006	-0.101
TIDF Compliance	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.010	0.010	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.000
Unit	0.000	-0.003	-0.022	0.051	0.241	0.008	0.055	0.142	0.129	0.047	0.004	-0.040	-0.027	0.051	0.230	0.086	0.000	0.010	0.046	0.029	0.011	-0.122	0.000	1.000	0.000	-0.070
Voluntary Soft-Story Retrofit	0.003	0.000	0.006	0.010	0.000	0.003	0.011	0.000	0.000	0.023	0.023	0.000	0.010	0.010	0.000	0.005	0.000	0.000	0.000	0.018	0.000	0.006	0.000	0.000	1.000	0.000
Zipcode	0.021	-0.049	0.245	0.052	0.083	0.008	0.997	-0.263	-0.269	-0.002	0.021	-0.200	0.264	0.054	0.075	-0.005	-0.050	0.015	0.147	0.037	0.017	-0.101	0.000	-0.070	0.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Permit Number	Permit Type	Permit Type Definition	Permit Creation Date	Block	Lot	Street Number	Street Name	Street Suffix	Description	Current Status	Current Status Date	Filed Date	Issued Date	Completed Date	First Construction Document Date	Structural Notification	Number of Existing Stories	Number of Proposed Stories	Voluntary Soft-Story Retrofit	Fire Only Permit	Permit Expiration Date	Existing Use	Proposed Use	Plansets	TIDF Compliance	Existing Construction Type	Existing Construction Type Description	Proposed Construction Type	Proposed Construction Type Description	Site Permit	Supervisor District	Neighborhoods - Analysis Boundaries	Zipcode	Location	Record ID
0	M788927	8	otc alterations permit	23/05/2017	0215	001	0.16	Jones	St	street space	issued	23/05/2017	23/05/2017	23/05/2017	01/01/1900	23/05/2017	False	0.00	0.00	False	False	21/02/2024	Desconocido	Desconocido	NaN	False	-1.00	NON AVAILABLE	-1.00	NON AVAILABLE	False	3.00	Nob Hill	94109.00	(37.79362102799777, -122.41488237355445)	1464153232862
1	201305318356	8	otc alterations permit	31/05/2013	1810	017A	0.18	43Rd	Av	remodel kitchen: replace countertop, cabinets, sink, stove, hardwood floor & lighting.	complete	28/08/2013	31/05/2013	03/06/2013	NaN	03/06/2013	False	0.04	0.04	False	False	29/05/2014	1 family dwelling	1 family dwelling	2.00	False	5.00	wood frame (5)	5.00	wood frame (5)	False	4.00	Sunset/Parkside	94122.00	(37.759041020475465, -122.50286985467523)	1306559115258
2	201705106205	8	otc alterations permit	10/05/2017	5700	027	0.05	Prentiss	St	replacement of 4 windows; 2 located in lightwell and 2 at front. replaceing existing vinyl windows with new wood-clad windows. no horizontal mullion in living room window	issued	11/05/2017	10/05/2017	11/05/2017	01/01/1900	11/05/2017	False	0.04	0.04	False	False	06/05/2018	1 family dwelling	1 family dwelling	0.00	False	5.00	wood frame (5)	5.00	wood frame (5)	False	9.00	Bernal Heights	94110.00	(37.73778863007536, -122.41197863877355)	1462579187173
3	201410279983	8	otc alterations permit	27/10/2014	0661	005	0.24	Bush	St	two kitchens & two bathrooms remodel. replace kitchen cabinets, countertops & appliances in same location. replace tub & faucet & vanity & tile in same location in both units.	complete	31/12/2014	27/10/2014	27/10/2014	NaN	27/10/2014	False	0.04	0.04	False	False	22/10/2015	2 family dwelling	2 family dwelling	0.00	False	5.00	wood frame (5)	5.00	wood frame (5)	False	5.00	Pacific Heights	94115.00	(37.78762264983362, -122.43099126735969)	136037778128
4	201310280388	8	otc alterations permit	28/10/2013	3642	051A	0.10	Capp	St	reroofing	issued	28/10/2013	28/10/2013	28/10/2013	01/01/1900	28/10/2013	False	0.04	0.04	False	False	23/10/2014	apartments	apartments	0.00	False	5.00	wood frame (5)	5.00	wood frame (5)	False	9.00	Mission	94110.00	(37.75275550565926, -122.41707462095194)	1322242163712
5	201307161925	8	otc alterations permit	16/07/2013	3565	076	0.41	16Th	St	to comply with physical inspection report #cc-7260 item #1 -all storage items are being removed.	complete	08/10/2013	16/07/2013	16/07/2013	10/08/2013	16/07/2013	False	0.05	0.05	False	False	11/07/2014	apartments	apartments	0.00	False	5.00	wood frame (5)	5.00	wood frame (5)	False	8.00	Castro/Upper Market	94114.00	(37.76416871595274, -122.43039745629406)	1311167285194
6	M501607	8	otc alterations permit	02/07/2014	3561	007	0.03	Noe	St	street space	issued	02/07/2014	02/07/2014	02/07/2014	01/01/1900	02/07/2014	False	0.00	0.00	False	False	21/02/2024	Desconocido	Desconocido	NaN	False	-1.00	NON AVAILABLE	-1.00	NON AVAILABLE	False	8.00	Castro/Upper Market	94114.00	(37.76519640087225, -122.4334386869886)	1347642247334
7	M787887	8	otc alterations permit	19/05/2017	0654	009	0.28	Pine	St	street space permit	issued	19/05/2017	19/05/2017	19/05/2017	01/01/1900	19/05/2017	False	0.00	0.00	False	False	21/02/2024	Desconocido	Desconocido	NaN	False	-1.00	NON AVAILABLE	-1.00	NON AVAILABLE	False	2.00	Pacific Heights	94115.00	(37.78814050763782, -122.43440743226256)	1463876236318
8	201404113025	8	otc alterations permit	11/04/2014	3740	029	0.01	Folsom	St	existing office and storage facility. new partitions, restroom upgrade. electrical on a separate permit	complete	02/10/2014	11/04/2014	25/04/2014	10/02/2014	25/04/2014	False	0.03	0.03	False	False	09/04/2017	office	office	2.00	False	3.00	constr type 3	3.00	constr type 3	False	6.00	Financial District/South Beach	94105.00	(37.78992343288329, -122.3915399961996)	1338371165676
9	201702109134	8	otc alterations permit	10/02/2017	0195	001	0.09	Montgomery	St	basement & 1/f- as built drawing for fire/smoke damper on hvac duct (existing) under pa#201612074341. n/a ordinance #155-13	complete	09/03/2017	10/02/2017	10/02/2017	03/09/2017	10/02/2017	False	0.06	0.06	False	False	05/02/2018	retail sales	retail sales	2.00	False	3.00	constr type 3	3.00	constr type 3	False	3.00	Chinatown	94111.00	(37.79621627942539, -122.40375479881872)	145294162223

	Permit Number	Permit Type	Permit Type Definition	Permit Creation Date	Block	Lot	Street Number	Street Name	Street Suffix	Description	Current Status	Current Status Date	Filed Date	Issued Date	Completed Date	First Construction Document Date	Structural Notification	Number of Existing Stories	Number of Proposed Stories	Voluntary Soft-Story Retrofit	Fire Only Permit	Permit Expiration Date	Existing Use	Proposed Use	Plansets	TIDF Compliance	Existing Construction Type	Existing Construction Type Description	Proposed Construction Type	Proposed Construction Type Description	Site Permit	Supervisor District	Neighborhoods - Analysis Boundaries	Zipcode	Location	Record ID
198900	201506027767	8	otc alterations permit	02/06/2015	7101A	007	0.09	Huron	Av	reroofing	complete	11/03/2016	02/06/2015	02/06/2015	03/11/2016	02/06/2015	False	0.04	0.04	False	False	27/05/2016	1 family dwelling	1 family dwelling	0.00	False	5.00	wood frame (5)	5.00	wood frame (5)	False	11.00	Outer Mission	94112.00	(37.71192805393076, -122.4500944316179)	1383549221502
198901	M871027	8	otc alterations permit	28/12/2017	1870	023	0.18	25Th	Av	street space	issued	28/12/2017	28/12/2017	28/12/2017	01/01/1900	28/12/2017	False	0.00	0.00	False	False	21/02/2024	Desconocido	Desconocido	NaN	False	-1.00	NON AVAILABLE	-1.00	NON AVAILABLE	False	4.00	Sunset/Parkside	94122.00	(37.75921574765919, -122.48300451049278)	1492023118112
198902	201609208175	8	otc alterations permit	20/09/2016	2130A	006G	0.01	Cragmont	Av	replace (e) tub with walk in tub, 20 amp circuit, gfci outlet	complete	28/09/2016	20/09/2016	20/09/2016	NaN	20/09/2016	False	0.04	0.04	False	False	15/09/2017	1 family dwelling	1 family dwelling	0.00	False	5.00	wood frame (5)	5.00	wood frame (5)	False	7.00	Inner Sunset	94116.00	(37.74973733662819, -122.4671301493082)	1438114126978
198903	201407161416	8	otc alterations permit	16/07/2014	2528	024	0.01	Crestlake	Dr	cut a door and a staircase for access to backyard.build deck next to staircase.	complete	23/01/2015	16/07/2014	28/10/2014	NaN	28/10/2014	True	0.04	0.04	False	False	23/10/2015	1 family dwelling	1 family dwelling	2.00	False	5.00	wood frame (5)	5.00	wood frame (5)	False	4.00	Sunset/Parkside	94132.00	(37.73542953855242, -122.48149902038024)	1349089138746
198904	M651047	8	otc alterations permit	30/12/2015	6176	008	0.04	Harkness	Av	street space	issued	30/12/2015	30/12/2015	30/12/2015	01/01/1900	30/12/2015	False	0.00	0.00	False	False	21/02/2024	Desconocido	Desconocido	NaN	False	-1.00	NON AVAILABLE	-1.00	NON AVAILABLE	False	10.00	Visitacion Valley	94134.00	(37.71765127619624, -122.40342209330782)	1407979197645
198905	201604053958	3	additions alterations or repairs	05/04/2016	7295	021	0.39	20Th	Av	ti for space 129,130, 132 partitions, mep, shelving, stonestown mall. ab -56 compliance 2014-0627-9771	complete	22/11/2016	05/04/2016	18/07/2016	NaN	18/07/2016	False	0.04	0.04	False	False	03/07/2019	retail sales	retail sales	2.00	False	2.00	constr type 2	2.00	constr type 2	False	7.00	Lakeshore	94132.00	(37.728556952954136, -122.47676641508518)	1418495226171
198906	201510270880	8	otc alterations permit	27/10/2015	4009	001A	0.23	Mariposa	St	install new 2" underground combination fire main. ref app#201402108156	issued	27/10/2015	27/10/2015	27/10/2015	01/01/1900	27/10/2015	False	0.05	0.05	False	True	21/10/2016	1 family dwelling	1 family dwelling	2.00	False	5.00	wood frame (5)	5.00	wood frame (5)	False	10.00	Potrero Hill	94107.00	(37.76328445631136, -122.40287014554292)	1400885168656
198907	201607293741	8	otc alterations permit	29/07/2016	4262	020	0.16	San Bruno	Av	replace rotten wooden moldings in kind front stairs less than 50% replace	issued	29/07/2016	29/07/2016	29/07/2016	01/01/1900	29/07/2016	False	0.04	0.04	False	False	24/07/2017	1 family dwelling	1 family dwelling	0.00	False	5.00	wood frame (5)	5.00	wood frame (5)	False	10.00	Mission	94110.00	(37.75260530951628, -122.40400191084352)	1431897172643
198908	201701066691	8	otc alterations permit	06/01/2017	0146	007	0.08	Broadway	St	revision to pa 2016-0926-8773; remove (e) storefront & doors, remove floor, ceiling & wall finishes for new. new storefront, (n) wall & ceiling finishes, (n) flooring with waterproofing in a (n) alcove. mep under pa#201503100377	issued	01/02/2017	06/01/2017	01/02/2017	01/01/1900	01/02/2017	False	0.04	0.04	False	False	27/01/2018	retail sales	retail sales	2.00	False	5.00	wood frame (5)	5.00	wood frame (5)	False	3.00	Chinatown	94133.00	(37.79800446861674, -122.4080339831039)	1449660232064
198909	201604255599	8	otc alterations permit	25/04/2016	3708	056	0.06	Market	St	16th floor - (4) evacuation plans.	issued	25/04/2016	25/04/2016	25/04/2016	01/01/1900	25/04/2016	False	0.49	0.49	False	True	20/04/2017	office	office	2.00	False	1.00	constr type 1	1.00	constr type 1	False	6.00	Financial District/South Beach	94105.00	(37.79040639954478, -122.39927546096968)	1420790164534

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters